﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="LikesReport.aspx.vb" Inherits="soccer.LikesReport" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .auto-style1 {
            font-size: medium;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <p class="auto-style1">
        <strong>Here are the numbers of likes for fixtures reported in this site</strong></p>
    <p class="auto-style1">
        &nbsp;</p>
    <p class="auto-style1">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="CountLikesDataSource">
            <Columns>
                <asp:BoundField DataField="fixtureID" HeaderText="Fixture ID" InsertVisible="False" SortExpression="fixtureID" />
                <asp:BoundField DataField="Team_1.teamName" HeaderText="Home Team" SortExpression="Team_1.teamName" />
                <asp:BoundField DataField="homeTeamScore" SortExpression="homeTeamScore" />
                <asp:BoundField DataField="Team.teamName" HeaderText="Away Team" SortExpression="Team.teamName" />
                <asp:BoundField DataField="awayTeamScore" SortExpression="awayTeamScore" />
                <asp:BoundField DataField="fixtureDate" HeaderText="Fixture Date" SortExpression="fixtureDate" />
                <asp:BoundField DataField="NumberOfLikes" HeaderText="Number Of Likes" SortExpression="NumberOfLikes" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="CountLikesDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SoccerConnectionString %>" ProviderName="<%$ ConnectionStrings:SoccerConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [CountLikesQuery] ORDER BY [NumberOfLikes] DESC"></asp:SqlDataSource>
    </p>
    <p class="auto-style1">
        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/resultlist.aspx">Back to Results List</asp:HyperLink>
    </p>
</asp:Content>
